# !/usr/bin/python3
# -*- coding: utf-8 -*-

"""
部门表模型类
----------------------------------------------------
@Project :   xinhou-openai-framework
@File    :   Dept.py
@Contact :   sp_hrz@qq.com

@Modify Time      @Author    @Version    @Desciption
------------      -------    --------    -----------
2023/04/16 22:04  peng.shen   v1.0.0     None
"""

from sqlalchemy import ForeignKey
from sqlalchemy import func

from sqlalchemy import Column, Integer, String, Text, Numeric, TIMESTAMP
from xinhou_openai_framework.core.orm.entity.BaseEntity import BaseEntity


class Dept(BaseEntity):
    # 数据表名&字段
    __tablename__ = 't_dept'

    parent_id = Column(Integer, default='0', comment="父部门id")
    dept_name = Column(String(30), comment="部门名称")
    order_num = Column(Integer, default='0', comment="显示顺序")
    leader = Column(String(20), comment="负责人")
    phone = Column(String(11), comment="联系电话")
    email = Column(String(50), comment="邮箱")
    status = Column(Integer, default='0', comment="部门状态:1=正常,2=停用")
    remark = Column(String(500), comment="备注")